*************** * FILE FILTER * *************** This is a utility with muscle. It allows you to create and save complex queries (filters) for your databases. ----------------------------- VIEWING AND SELECTING A QUERY ----------------------------- When you enter you will see a window containing descriptions of all available queries, along with the database aliases to which they correspond. ACTIVE KEYS ----------- UpArrow Move highlight bar up one query DownArrow Move highlight bar down one query F7 Counts records matching current query F8 Delete current query F9 View criteria for current query F10 Create a new query Enter Run current query Esc Exit the query module -------------------- CREATING A NEW QUERY -------------------- Viewing field names and descriptions ------------------------------------ Pressing [F10] from the query window will bring up the criteria screen. A scrolling window containing field names of your database will appear on the right of the screen. The following commands are available: Enter Select current field UpArrow Move highlight bar up DownArrow Move highlight bar down Letters(A-Z) Move to the next field beginning with that letter Selecting an operator --------------------- Pressing [ENTER] will bring up the operators window, which contains the following choices: a) Equal to b) Less than c) Greater than d) Less than or equal to e) Greater than or equal to f) Not equal to g) Contains h) Sounds like Use the Up and DownArrow to select the desired operator, the press [ENTER] to continue. Selecting a value ----------------- When you have selected an operator, another window will appear below the operators window. This window will contain the field name and the operator. Type in the desired value for this field, then press [ENTER]. If you wish to see all the available values in your database, press [ALT]-[V] to pop up a scrolling window of the values. You may select one of these by highlighting it and then press [ENTER], or you may press [ESC] to exit without selecting anything. Selecting a Boolean operator ---------------------------- When you have entered the value, another window will appear below the value window. This window contains the following choices: a) "Discard" b) ".AND." c) ".OR." d) ".AND(" e) ".OR(" f) ").AND." g) ").OR." h) "<>" Move the highlight bar to the desired selection, and press [ENTER]. You will note that option f) and g) will not be available to you until you have embedded an open parenthesis in your query. Ending the query ---------------- When you are finished building the criteria for this query, select <> from the Boolean operator window. You will then be asked to enter a description for this query for future reference. The description may contain up to fifty characters. Press [ENTER] when you are finished entering the description, and you will be returned to the query window. If you want to exit without saving this query press [ESC]. If you wish to run this query immediately without saving it for future use, simply leave the description empty and press [ENTER].